200 |
How do I arrange my columns on multiple lines
With Excombobox1 .HeaderHeight = 32 .Columns.Add("").HTMLCaption = "Line 1<br>Line 2" End With |
199 |
How can I display all cells using HTML format
|
198 |
How can I display all cells using multiple lines
With Excombobox1 .Columns.Add("MultipleLine").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,False) .Columns.Add("SingleLine").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,True) With .Items .set_CellCaption(.AddItem("This is a bit of long text that should break the line"),1,"this is a bit of long text that's displayed on a single line") End With End With |
197 |
How do change the vertical alignment for all cells in the column
With Excombobox1 .Columns.Add("MultipleLine").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,False) .Columns.Add("VAlign").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellVAlignment,2) With .Items .set_CellCaption(.AddItem("This is a bit of long text that should break the line"),1,"bottom") End With With .Items .set_CellCaption(.AddItem("This is a bit of long text that should break the line"),1,"bottom") End With End With |
196 |
How do change the foreground color for all cells in the column
|
195 |
How do change the background color for all cells in the column
|
194 |
How do I show buttons for all cells in the column
With Excombobox1 With .Columns.Add("Button") .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasButton,True) .set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellButtonAutoWidth,True) End With .Items.AddItem(" Button 1 ") .Items.AddItem(" Button 2 ") End With |
193 |
How do I show buttons for all cells in the column
With Excombobox1 .Columns.Add("Button").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasButton,True) .Items.AddItem(0) .Items.AddItem(1) End With |
192 |
How do I display radio buttons for all cells in the column
With Excombobox1 .Columns.Add("Radio").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasRadioButton,True) .Items.AddItem(0) .Items.AddItem(1) End With |
191 |
How do I display checkboxes for all cells in the column
With Excombobox1 .Columns.Add("Check").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) .Items.AddItem(0) .Items.AddItem(1) End With |
190 |
How can I display a tooltip when the cursor hovers the column
|
189 |
Is there any function to assign a key to a column instead using its name or capion
|
188 |
Is there any function to assign any extra data to a column
|
187 |
By default, the column gets sorted descending, when I first click its header. How can I change so the column gets sorted ascending when the user first clicks the column's header
With Excombobox1 .Columns.Add("Sort").DefaultSortOrder = True End With |
186 |
How can I specify the maximum width for the column, if I use WidthAutoResize property
With Excombobox1 With .Columns.Add("Auto") .WidthAutoResize = True .MinWidthAutoResize = 32 .MaxWidthAutoResize = 128 End With .Items.AddItem(0) .Items.AddItem(1) End With |
185 |
How can I specify the minimum width for the column, if I use WidthAutoResize property
With Excombobox1 With .Columns.Add("Auto") .WidthAutoResize = True .MinWidthAutoResize = 32 End With .Items.AddItem(0) .Items.AddItem(1) End With |
184 |
Is there any option to resize the column based on its data, captions
With Excombobox1 .Columns.Add("A").WidthAutoResize = True .Items.AddItem(0) .Items.AddItem(1) End With |
183 |
How can I align the icon in the column's header in the center
|
182 |
How do I align the icon in the column's header to the right
|
181 |
How do I show or hide the sorting icons, but still need sorting
With Excombobox1 .Columns.Add("Sorted").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending .Columns.Item(0).DisplaySortIcon = False End With |
180 |
How do I enable or disable the entire column
With Excombobox1 .Columns.Add("C1") .Columns.Add("Disabled").Enabled = False With .Items .set_CellCaption(.AddItem(0),1,"0.1") End With With .Items .set_CellCaption(.AddItem(1),1,"1.1") End With End With |
179 |
How do I disable drag and drop columns
With Excombobox1 .Columns.Add("C1").AllowDragging = False .Columns.Add("C2").AllowDragging = False End With |
178 |
How do I disable resizing a column at runtime
With Excombobox1 .Columns.Add("Unsizable").AllowSizing = False .Columns.Add("C2") .Columns.Add("C3") .Columns.Add("C4") End With |
177 |
How can I align the column to the right, and its caption too
With Excombobox1 With .Columns.Add("Column") .Alignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment .HeaderAlignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment End With .Items.AddItem(0) .Items.AddItem(1) End With |
176 |
How can I align the column to the right
|
175 |
How do I change the column's caption
|
174 |
Can I change the visual effect, appearance for the anchor, hyperlink elements, in HTML captions, after the user clicks it
With Excombobox1 .set_FormatAnchor(False,"<b><u><fgcolor=880000> </fgcolor></u></b>") .Columns.Add("Column") With .Items .set_CellCaptionFormat(.AddItem("Just an <a1>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML) End With With .Items .set_CellCaptionFormat(.AddItem("Just another <a2>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML) End With .Items.AddItem("next item") End With |
173 |
Can I change the visual effect, appearance for the anchor, hyperlink elements, in HTML captions
With Excombobox1 .set_FormatAnchor(True,"<b><u><fgcolor=FF0000> </fgcolor></u></b>") .Columns.Add("Column") With .Items .set_CellCaptionFormat(.AddItem("Just an <a1>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML) End With With .Items .set_CellCaptionFormat(.AddItem("Just another <a2>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML) End With End With |
172 |
Can I change the font for the tooltip
|
171 |
Can I change the font for the tooltip
With Excombobox1 .ToolTipDelay = 1 With .ToolTipFont .Name = "Tahoma" .Size = 14 End With .ToolTipWidth = 364 .Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" End With |
170 |
Can I change the order of the buttons in the scroll bar
With Excombobox1 .set_ScrollOrderParts(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,"t,l,r") .set_ScrollOrderParts(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exVScroll,"t,l,r") End With |
169 |
The thumb size seems to be very small. Can I make it bigger
With Excombobox1 .ColumnAutoResize = False .Columns.Add("C1").Width = 256 .Columns.Add("C2").Width = 256 .Columns.Add("C3").Width = 256 .set_ScrollThumbSize(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,64) End With |
168 |
How can I display my text on the scroll bar, using a different font
With Excombobox1 .set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exThumbPart,"This is <s><font Tahoma;12> just </font></s> text") .ColumnAutoResize = False .ScrollHeight = 20 .Columns.Add("C1").Width = 256 .Columns.Add("C2").Width = 256 .Columns.Add("C3").Width = 256 End With |
167 |
How can I display my text on the scroll bar, using a different font
With Excombobox1 .set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exThumbPart,"This is just a text") .get_ScrollFont(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll).Size = 12 .ColumnAutoResize = False .ScrollHeight = 20 .Columns.Add("C1").Width = 256 .Columns.Add("C2").Width = 256 .Columns.Add("C3").Width = 256 End With |
166 |
How can I display my text on the scroll bar
With Excombobox1 .set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exThumbPart,"this is just a text") .ColumnAutoResize = False .Columns.Add("C1").Width = 256 .Columns.Add("C2").Width = 256 .Columns.Add("C3").Width = 256 End With |
165 |
How do I enlarge or change the size of the control's scrollbars
With Excombobox1 .ScrollHeight = 18 .ScrollWidth = 18 .ScrollButtonWidth = 18 .ScrollButtonHeight = 18 End With |
164 |
How do I assign a tooltip to a scrollbar
With Excombobox1 .set_ScrollToolTip(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,"This is a tooltip being shown when you click and drag the thumb in the horizontal scroll bar") .ColumnAutoResize = False .Columns.Add("C1").Width = 256 .Columns.Add("C2").Width = 256 .Columns.Add("C3").Width = 256 End With |
163 |
How do I assign an icon to the button in the scrollbar
With Excombobox1 .Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" & _ "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" & _ "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _ "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,True) .set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,"<img>1</img>") .ScrollHeight = 18 .ScrollButtonWidth = 18 End With |
162 |
I need to add a button in the scroll bar. Is this possible
With Excombobox1 .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,True) .set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,"1") End With |
161 |
Can I display an additional buttons in the scroll bar
With Excombobox1 .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,True) .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB2Part,True) .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exRightB6Part,True) .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exRightB5Part,True) End With |
160 |
How can I display a custom size picture to a cell or item
|
159 |
How can I display a multiple pictures to a cell or item
With Excombobox1 .DefaultItemHeight = 48 .set_HTMLPicture("pic1","c:\exontrol\images\zipdisk.gif") .set_HTMLPicture("pic2","c:\exontrol\images\auction.gif") .Columns.Add("C1") With .Items .set_CellCaptionFormat(.AddItem("<img>pic1</img> Text <img>pic2</img> another text ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML) End With End With |
158 |
How do I change the column's foreground color for numbers between an interval - Range
With Excombobox1 With .ConditionalFormats.Add("%0 >= 2 and %0 <= 10") .Bold = True .ForeColor = Color.FromArgb(255,0,0) .ApplyTo = &H1 End With .Columns.Add("N1") .Columns.Add("N2") With .Items .set_CellCaption(.AddItem(1),1,2) End With With .Items .set_CellCaption(.AddItem(3),1,3) End With With .Items .set_CellCaption(.AddItem(10),1,11) End With With .Items .set_CellCaption(.AddItem(13),1,31) End With .SearchColumnIndex = 1 End With |
157 |
How do I change the item's foreground color for numbers between an interval - Range
With Excombobox1 .ConditionalFormats.Add("%0 >= 2 and %0 <= 10").ForeColor = Color.FromArgb(255,0,0) .Columns.Add("Numbers") .Items.AddItem(1) .Items.AddItem(2) .Items.AddItem(10) .Items.AddItem(20) End With |
156 |
How do I change the item's background color for numbers less than a value
With Excombobox1 .ConditionalFormats.Add("%0 < 10").BackColor = Color.FromArgb(255,0,0) .Columns.Add("Numbers") .Items.AddItem(1) .Items.AddItem(2) .Items.AddItem(10) .Items.AddItem(20) End With |
155 |
How do I underline the numbers greater than a value
With Excombobox1 .ConditionalFormats.Add("%0 >= 10").Underline = True .Columns.Add("Numbers") .Items.AddItem(1) .Items.AddItem(2) .Items.AddItem(10) .Items.AddItem(20) End With |
154 |
How do I highlight in italic the numbers greater than a value
With Excombobox1 .ConditionalFormats.Add("%0 >= 10").StrikeOut = True .Columns.Add("Numbers") .Items.AddItem(1) .Items.AddItem(2) .Items.AddItem(10) .Items.AddItem(20) End With |
153 |
How do I highlight in italic the numbers greater than a value
With Excombobox1 .ConditionalFormats.Add("%0 >= 10").Italic = True .Columns.Add("Numbers") .Items.AddItem(1) .Items.AddItem(2) .Items.AddItem(10) .Items.AddItem(20) End With |
152 |
How do I highlight in bold the numbers greater than a value
With Excombobox1 .ConditionalFormats.Add("%0 >= 10").Bold = True .Columns.Add("Numbers") .Items.AddItem(1) .Items.AddItem(2) .Items.AddItem(10) .Items.AddItem(20) End With |
151 |
Can I use your EBN files to change the visual appearance for +/- expand - collapse buttons
Dim h With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot .HasButtons = exontrol.EXCOMBOBOXLib.ExpandButtonEnum.exCustom .set_HasButtonsCustom(False,16777216) .set_HasButtonsCustom(True,33554432) .Columns.Add("Column") With .Items h = .AddItem("Root 1") .InsertItem(h,Nothing,"Child 1") .InsertItem(h,Nothing,"Child 2") .set_ExpandItem(h,True) h = .AddItem("Root 2") .InsertItem(h,Nothing,"Child") End With End With |
150 |
Can I use your EBN files to change the visual appearance for radio buttons
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .set_RadioImage(False,16777216) .set_RadioImage(True,33554432) .Columns.Add("Radio").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasRadioButton,True) With .Items .AddItem("Radio 1") .set_CellState(.AddItem("Radio 2"),0,1) .AddItem("Radio 3") End With End With |
149 |
Can I use your EBN files to change the visual appearance for checkbox cells
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .set_CheckImage(exontrol.EXCOMBOBOXLib.CheckStateEnum.Unchecked,16777216) .set_CheckImage(exontrol.EXCOMBOBOXLib.CheckStateEnum.Checked,33554432) .Columns.Add("Check").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True) With .Items .AddItem("Check 1") .set_CellState(.AddItem("Check 2"),0,1) End With End With |
148 |
How do I change the visual aspect for thumb parts in the scroll bars, using EBN
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumb,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumbP,&H2000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumbH,&H3000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exVSThumb,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exVSThumbP,&H2000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exVSThumbH,&H3000000) .ColumnAutoResize = False .ScrollBySingleLine = True .Columns.Add("S").Width = 483 With .Items .set_ItemHeight(.AddItem("Item 1"),248) End With .Items.AddItem("Item 2") End With |
147 |
How do I change the visual aspect only for the thumb in the scroll bar, using EBN
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumb,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumbP,&H2000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumbH,&H3000000) .ColumnAutoResize = False .Columns.Add("S").Width = 483 End With |
146 |
I've seen that you can change the visual appearance for the scroll bar. How can I do that
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSBtn,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSBtnP,&H2000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSBtnH,&H3000000) .set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSBack,Color.FromArgb(240,240,240)) .set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240)) .set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSBackH Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exToolTipAppearance Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exCursorHoverColumn Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateHeader,Color.FromArgb(240,240,240)) .Columns.Add("S").Width = 32 .Columns.Add("Level 1").LevelKey = 1 .Columns.Add("Level 2").LevelKey = 1 .Columns.Add("Level 3").LevelKey = 1 .Columns.Add("E1").Width = 32 .Columns.Add("E2").Width = 32 .Columns.Add("E3").Width = 32 .Columns.Add("E4").Width = 32 .ColumnAutoResize = False End With |
145 |
Is there any option to highligth the column from the cursor - point
|
144 |
How do I change the visual aspect of selected item in the drop down filter window, using your EBN technology
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSelBackColorFilter,&H1000000) .set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSelForeColorFilter,Color.FromArgb(255,20,20)) .Columns.Add("Filter").DisplayFilterButton = True End With |
143 |
How do I change the visual aspect of the drop down calendar window, that shows up if I click the drop down filter button, using EBN
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateHeader,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateTodayUp,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateTodayDown,&H2000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateScrollThumb,&H1000000) .set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateScrollRange,Color.FromArgb(230,230,230)) .set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateSeparatorBar,Color.FromArgb(230,230,230)) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateSelect,&H1000000) With .Columns.Add("Date") .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exDate .DisplayFilterButton = True .DisplayFilterDate = True End With End With |
142 |
How do I change the visual aspect of the close button in the filter bar, using EBN
|
141 |
How do I change the visual aspect of buttons in the cell, using EBN
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exCellButtonUp,&H1000000) .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSizeGrip,&H2000000) .SelForeColor = Color.FromArgb(0,0,0) .ShowFocusRect = False .Columns.Add("Column 1").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasButton,True) .Items.AddItem("Button 1") .Items.AddItem("Button 2") .Columns.Add("Column 2") End With |
140 |
How do I change the visual aspect of the drop down filter button, using EBN
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHeaderFilterBarButton,&H1000000) .Columns.Add("Filter").DisplayFilterButton = True End With |
139 |
Is there any function to get the control's data in your x-script format / template
With Excombobox1 .Columns.Add("Column") .Items.AddItem("ToTemplate()") End With |
138 |
How do I enable resizing the columns at runtime
With Excombobox1 .ColumnsAllowSizing = True .MarkSearchColumn = False .HeaderVisible = False .Columns.Add("Column 1") .Columns.Add("Column 2") .DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines With .Items .set_CellCaption(.AddItem("Item 1"),1,"Sub Item 1") End With With .Items .set_CellCaption(.AddItem("Item 2"),1,"Sub Item 2") End With End With |
137 |
How do I enable resizing ( changing the height ) the items at runtime
With Excombobox1 .ItemsAllowSizing = exontrol.EXCOMBOBOXLib.ItemsAllowSizingEnum.exResizeItem .ScrollBySingleLine = True .Columns.Add("Column") .Items.AddItem("Item 1") With .Items .set_ItemHeight(.AddItem("Item 2"),48) End With .Items.AddItem("Item 3") End With |
136 |
How can I sort by multiple columns
With Excombobox1 .SingleSort = False .Columns.Add("C1").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending .Columns.Add("C2").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortDescending .Columns.Add("C3").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending End With |
135 |
How can I add several columns to control's sort bar
With Excombobox1 .SortBarVisible = True .SortBarColumnWidth = 48 .Columns.Add("C1").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending .Columns.Add("C2").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortDescending End With |
134 |
How can I change the width of the columns being displayed in the sort bar
With Excombobox1 .SortBarVisible = True .SortBarColumnWidth = 48 .Columns.Add("C1").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending .Columns.Add("C2").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortDescending End With |
133 |
How can I change the height of the sort bar's
With Excombobox1 .SortBarVisible = True .SortBarHeight = 48 End With |
132 |
How can I change the sort bar's foreground color
With Excombobox1 .SortBarVisible = True .ForeColorSortBar = Color.FromArgb(255,0,0) End With |
131 |
How can I change the visual appearance of the control's sort bar, using EBN files
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .SortBarVisible = True .BackColorSortBar32 = &H1000000 .BackColorSortBarCaption32 = &H2000000 .Appearance = exontrol.EXCOMBOBOXLib.AppearanceEnum.None2 End With |
130 |
How can I change the sort bar's background color
With Excombobox1 .SortBarVisible = True .BackColorSortBar = Color.FromArgb(255,0,0) .BackColorSortBarCaption = Color.FromArgb(128,0,0) End With |
129 |
How can I change the default caption being displayed in the control's sort bar
With Excombobox1 .SortBarVisible = True .SortBarCaption = "new caption" End With |
128 |
How can I show the locked / fixed items on the bottom side of the control
With Excombobox1 .ShowLockedItems = True .Columns.Add("Column") With .Items .set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exMiddle,2) .set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exMiddle,0),0,"locked item 1") .set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exMiddle,1),0,"locked item 2") .AddItem("un-locked item") End With End With |
127 |
How can I show the locked / fixed items
With Excombobox1 .ShowLockedItems = True .Columns.Add("Column") With .Items .set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,2) .set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),0,"locked item 1") .set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,1),0,"locked item 2") .AddItem("un-locked item") End With End With |
126 |
How can I hide the locked / fixed items
With Excombobox1 .ShowLockedItems = False .Columns.Add("Column") With .Items .set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,1) .set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),0,"locked item") .AddItem("un-locked item") End With End With |
125 |
How can I show the control's sort bar
With Excombobox1 .SortBarVisible = True End With |
124 |
How can I change the header's background color, when multiple levels are displayed
With Excombobox1 .BackColorLevelHeader = Color.FromArgb(250,0,0) .Columns.Add("S").Width = 32 .Columns.Add("Level 1").LevelKey = 1 .Columns.Add("Level 2").LevelKey = 1 .Columns.Add("Level 3").LevelKey = 1 End With |
123 |
How do I expand automatically the items while user types characters to searching for something ( incremental searching )
With Excombobox1 .ExpandOnSearch = True .LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot .AutoSearch = True .Columns.Add("Column").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exContains With .Items .InsertItem(.InsertItem(.AddItem("text"),Nothing,"some text"),Nothing,"another text") .InsertItem(.InsertItem(.AddItem("text"),Nothing,"some text"),Nothing,"another text") End With End With |
122 |
Do you have some function to load data from a safe array
|
121 |
Do you have some function to retrieve all items to a safe array
With Excombobox1 .Columns.Add("Column") .Items.AddItem(0) .PutItems(.GetItems(0)) .Items.AddItem(1) .PutItems(.GetItems(0)) .Items.AddItem(2) .PutItems(.GetItems(0)) .Items.AddItem(3) End With |
120 |
How can I hide a column
With Excombobox1 .Columns.Add("Hidden").Visible = False .Columns.Add("2") .Columns.Add("3") .Columns.Add("4") .Columns.Add("5") End With |
119 |
I've seen that the width of the tooltip is variable. Can I make it larger
With Excombobox1 .ToolTipWidth = 328 .Columns.Add("tootip").ToolTip = "this is a tooltip that should be very very very very very very very long" End With |
118 |
How do I disable showing the tooltip for all control
With Excombobox1 .ToolTipDelay = 0 .Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" End With |
117 |
How do I let the tooltip being displayed longer
With Excombobox1 .ToolTipPopDelay = 10000 .Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" End With |
116 |
How do I show the tooltip quicker
With Excombobox1 .ToolTipDelay = 1 .Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column" End With |
115 |
How do I change the caption being displayed in the control's filter bar
With Excombobox1 .FilterBarCaption = "your filter caption" With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks End With .ApplyFilter() End With |
114 |
How do I search case sensitive, using your incremental search feature
With Excombobox1 .AutoSearch = True .ASCIILower = "" With .Columns .Add("exStartWith").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exStartWith .Add("exContains").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exContains End With With .Items .set_CellCaption(.AddItem("text"),1,"another text") End With With .Items .set_CellCaption(.AddItem("text"),1,"another text") End With End With |
113 |
How do I disable the control
With Excombobox1 .Enabled = False End With |
112 |
How do I enable the incremental search feature within a column
With Excombobox1 .AutoSearch = True With .Columns .Add("exStartWith").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exStartWith .Add("exContains").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exContains End With With .Items .set_CellCaption(.AddItem("text"),1,"another text") End With With .Items .set_CellCaption(.AddItem("text"),1,"another text") End With End With |
111 |
How do I call your x-script language
With Excombobox1 With .ExecuteTemplate("Columns.Add(`Column`)") .HeaderStrikeOut = True .HeaderBold = True End With End With |
110 |
How do I call your x-script language
|
109 |
How do I show alternate rows in different background color
|
108 |
How do I enlarge the drop down filter window
With Excombobox1 .FilterBarDropDownHeight = "-320" With .Columns.Add("Column") .DisplayFilterButton = True .FilterBarDropDownWidth = "-320" End With .Items.AddItem("Item 1") .Items.AddItem("Item 2") End With |
107 |
How do I filter programatically the control
With Excombobox1 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern .Filter = "Item*" End With .Items.AddItem("Item 1") .Items.AddItem("") .Items.AddItem("Item 2") .ApplyFilter() End With |
106 |
How do I change the font of the control's filterbar
With Excombobox1 .FilterBarFont.Size = 20 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks End With .ApplyFilter() End With |
105 |
Can I apply an EBN skin to the control's filter bar so I can change its visual appearance
With Excombobox1 .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .FilterBarBackColor32 = &H1000000 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks End With .ApplyFilter() End With |
104 |
How do I change the background color of the control's filterbar
With Excombobox1 .FilterBarBackColor = Color.FromArgb(240,240,240) With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks End With .ApplyFilter() End With |
103 |
How do I change the foreground color of the control's filterbar
With Excombobox1 .FilterBarForeColor = Color.FromArgb(255,0,0) With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks End With .ApplyFilter() End With |
102 |
How do I change the height of the control's filterbar
With Excombobox1 .FilterBarHeight = 32 With .Columns.Add("Column") .DisplayFilterButton = True .FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks End With .ApplyFilter() End With |
101 |
How do I change the header's foreground color
|